BHARAT SEVAK SAMAJ
Time: 2 hrs. Max. Marks: 100
I. Fill in the blanks: (10 x 1 = 10)
1. To make changes to permanent in a table ………….. command is used.
2. .......... is a constraint for the column of a table.
3. INSERT is a .......... command.
4. To exit from SQL….......... command is used.
5. .......... operation is used to access rows from two or more tables.
6. .......... function returns the absolute value of data.
7. To modify the structure of a table…........... command is used.
8. To produce summary information for the rows of a table ….......... clause is used.
9. ............is a logical table that allows to access data from other tables.
10. ............is a buffer which will store the results of the recent query.
II. State whether True or False: (10 x 1 = 10)
1. Exceptions are situations without an error.
2. The cursor must be defined in the ‘Declare’ section of the program.
3. Procedures are subprograms that are generally coded to compute some value.
4. GRANT is a DML command.
5. To delete rows from a table, DEL command is used.
6. DDL stands for Data Definition Language.
7. Constraints are rules to control the data in a column.
8. END command is used to exit from SQL.
9. ROLL BACK command is used to make the changes permanently in a table.
10. Primary key is a constraint for the column of a table.
III.Answer any SIX of the following: (6 x 10 = 60)
1. How will you create a table in MS Access?
2. Explain the constraints and data types used in SQL.
3. Explain SQL Divisions.
4. Explain cursor management. Explain cursor attributes.
5. Write a PL/SQL Program to check whether a given number is prime or not.
6. Explain the subprograms in Oracle.
7. What are the uses of 'Forms' in MS Access?
III.Answer any ONE of the following: (1 x 20 = 20)
1. Explain in detail about Exceptions.
2. Explain Codd’s Rules.